package com.hubu.jwxt.beans;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Teacher {
    /*    CREATE TABLE `teacher`  (
            `t_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
            `t_num` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '老师学工号',
            `t_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '老师姓名',
            `t_pwd` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '老师密码',
            `t_sex` enum('男','女') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '老师性别，枚举类型',
            `t_age` int(5) NOT NULL COMMENT '老师年龄',
            `t_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '老师手机',
            `t_email` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '老师邮箱',
            `p_id` int(11) NOT NULL COMMENT '老师所属专业的ID',
    PRIMARY KEY (`t_id`) USING BTREE,
    INDEX `p_id_t`(`p_id`) USING BTREE,
    CONSTRAINT `p_id_t` FOREIGN KEY (`p_id`) REFERENCES `professional` (`p_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;*/

    private int t_id;
    private String t_num;
    private String t_name;
    private String t_pwd;
    private Enum.Sex t_sex;
    private int t_age;
    private String t_phone;
    private String t_email;
    private int p_id;
}
